package com.telecom.mapper;

import com.telecom.entity.Staff;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface StaffDao {
    /*@Select("<script>"+
            "select * from staff" +
            "        <where>" +
            "            <if test=\"addr != null and addr != ''\">" +
            "                and addr like '%${addr}%'" +
            "            </if>" +
            "        </where>"+
            "</script>"
    )*/
    @Select({"<script>",
            "select * from staff" ,
            "        <where>" ,
            "            <if test=\"addr != null and addr != ''\">" ,
            "                and addr like '%${addr}%'" ,
            "            </if>" ,
            "        </where>",
            "</script>"}
    )
    List<Staff> selectByAddr(String addr);
}
